﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="MrjSaleRpt.aspx.cs" Inherits="MrjSaleRpt" %>

<%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>每人计销售报表分析</title>
    <script src="../js/extTools.js" type="text/javascript"></script>
    <script src="../js/jquery/jquery-1.8.1.min.js" type="text/javascript"></script>
    <script src="../js/jquery/jquery.iDialog.js" dialog-theme="default" type="text/javascript"></script>
    <script src="../js/config.js" type="text/javascript"></script>
    <style>
        .x-grid-row-over .x-grid-cell-inner
        {
            font-weight: bold;
        }
        .x-column-header-inner
        {
            height: 28px;
            background: #E7EBEF url(./images/header.png) repeat-x 0 0;
        }
    </style>
    <script>
        var onRowDoubleClick = function (grid, rowIndex, e) {
            //alert(grid.getStore().getAt(rowIndex));
            //            var selectionModel = grid.getSelectionModel();
            //            var record = selectionModel.getSelected();
            //            alert(record.data.美人计店铺编号);
        }
        var change = function (value) {
            return Ext.String.format(template, (parseInt(value.substring(0, value.length - 1)) < 0) ? "red" : "green", value);
        };
        var tbchange = function (value) {
            return Ext.String.format(template, "blue", value);
        };
        var exportData2 = function (format) {
            App.FormatType.setValue(format);
            var store = App.GridPanel2.store;
            store.submitData(null, { isUpload: true });
        };
        var exportData3 = function (format) {
            App.FormatType.setValue(format);
            var store = App.GridPanel3.store;
            store.submitData(null, { isUpload: true });
        };
        $(function () {
            $('#btn_findshop').click(function () {
                getshop($("#txt_shopname").val());
            });
            $('#chkclear').click(function () {
                $('#shop-list input[type="checkbox"]').each(function () {
                    if ($(this).attr('checked') == true) {
                        $(this).click();
                    }
                });
                $('#select-shop').text('');
                $('#txt_shop').val('');
            });
        });
        function showshop() {
            //alert(App.selectshop.getValue());
            if (App.selectshop.getValue() == "") {
                getshop("");
            }
            $.dialog({
                lock: true,
                fixed: true,
                title: '选择店铺',
                width: 800,
                btn: {
                    ok: {
                        val: '确定',
                        type: 'blue',
                        click: function (btn) {
                            var shop = $("#select_shop").text();
                            App.selectshop.setValue($("#txt_shop").val());
                        }
                    },
                    cancle: {
                        val: '取消',
                        type: 'red'
                    }
                },
                content: document.getElementById("my-shop")
            });

        }
        function getshop(val) {
            $.post(url_path + "/MrjControler.aspx",
                { aciton: 'lodshoplist', shopname: val },
                    function (data) {
                        var html = "";
                        var msg = $.trim(data);
                        if (msg == "NO_DATA") {
                            html = "<tr><td>没有数据！</td></tr>"
                        } else {
                            var orderObj = JSON.parse(msg);
                            for (var i = 0; i < orderObj.length; i++) {
                                html += '<div style ="float:left; width:240px;"><input type="checkbox" name="' + orderObj[i].shopname + '" value="' + orderObj[i].shopid + '">' +
                                '<label>' + orderObj[i].shopname + '</label></div>';
                            }
                        }
                        $("#shop-list").html(html);
                        //$('#select_shop').text("");
                        $('#shop-list input[type="checkbox"]').each(function () {
                            $(this).click(function () {
                                var val = $('#select_shop').text();
                                var val2 = $('#txt_shop').val();
                                var chkVal = $(this).val();
                                var chkName = $(this).attr('name');
                                
                                if ($(this).attr('checked') == "checked") {
                                    $('#select_shop').text(val + chkVal + ',');
                                    $('#txt_shop').val(val2 + chkName + ',');
                                }
                                else {
                                    var result = val.replace(new RegExp(chkVal + ',', 'gm'), '');
                                    $('#select_shop').text(result);
                                    //$('#txt_shop').val(val2.replace(chkName + ',', ''));
                                    $('#txt_shop').val(val2.replace(new RegExp(chkName + ',', 'gm'), ''));
                                }
                            })
                        });
                    });
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <ext:ResourceManager ID="ResourceManager1" runat="server" Theme="Neptune" />
        <ext:Hidden ID="FormatType" runat="server" />
        <ext:Hidden ID="hd_mrjshopid" runat="server" />
        <ext:Viewport ID="Viewport1" runat="server">
            <LayoutConfig>
                <ext:HBoxLayoutConfig Align="Stretch" />
            </LayoutConfig>
            <Defaults>
                <ext:Parameter Name="margin" Value="2 0" Mode="Value" />
            </Defaults>
            <Items>
                <ext:TabPanel ID="TabPanel1" runat="server" Flex="1">
                    <TopBar>
                        <ext:Toolbar runat="server" Layout="ColumnLayout">
                            <Items>
                                <ext:DateField runat="server" ID="txtdaybdate" LabelWidth="60" FieldLabel="本期日期"
                                    Width="200" />
                                <ext:DateField runat="server" ID="txtdayedate" LabelWidth="60" FieldLabel="上期日期"
                                    Width="200" />
                                <ext:TextField runat="server" ID="txtweek" LabelWidth="60" FieldLabel="本周" Width="150" />
                                <ext:TextField runat="server" ID="txtmonth" LabelWidth="60" FieldLabel="本月" Width="150" />
                                <ext:Component ID="Component1" runat="server" Width="1500" Margin="3" />
                                <ext:DateField runat="server" ID="txtbdate" LabelWidth="100" FieldLabel="本期－开始日期"
                                    Width="200" />
                                <ext:DateField runat="server" ID="txtedate" LabelWidth="100" FieldLabel="本期－结束日期"
                                    Width="200" />
                                <ext:DateField runat="server" ID="txtubdate" LabelWidth="100" FieldLabel="上期－开始日期"
                                    Width="200" />
                                <ext:DateField runat="server" ID="txtuedate" LabelWidth="100" FieldLabel="上期－结束日期"
                                    Width="200" />
                                <ext:Component ID="Component2" runat="server" Width="1500" Margin="3" />
                                <ext:ComboBox runat="server" ID="txtdayoperation" DisplayField="OperationAreaName"
                                    QueryMode="Local" TypeAhead="true" ValueField="OperationAreaName" Width="150"
                                    FieldLabel="大区" LabelWidth="60">
                                    <Store>
                                        <ext:Store ID="Store_OperationAreaName" runat="server" AutoDataBind="true">
                                            <Model>
                                                <ext:Model ID="Model5" runat="server">
                                                    <Fields>
                                                        <ext:ModelField Name="OperationAreaName" />
                                                    </Fields>
                                                </ext:Model>
                                            </Model>
                                        </ext:Store>
                                    </Store>
                                    <DirectEvents>
                                        <Change OnEvent="GetBigArea" />
                                    </DirectEvents>
                                </ext:ComboBox>
                                <ext:ComboBox runat="server" ID="txtdaybigarea" DisplayField="BigAreaName" QueryMode="Local"
                                    TypeAhead="true" ValueField="BigAreaName" Width="200" FieldLabel="省份" LabelWidth="60">
                                    <Store>
                                        <ext:Store ID="Store_BigAreaName" runat="server" AutoDataBind="true">
                                            <Model>
                                                <ext:Model ID="Model6" runat="server">
                                                    <Fields>
                                                        <ext:ModelField Name="BigAreaName" />
                                                    </Fields>
                                                </ext:Model>
                                            </Model>
                                        </ext:Store>
                                    </Store>
                                    <DirectEvents>
                                        <Change OnEvent="GetArea" />
                                    </DirectEvents>
                                </ext:ComboBox>
                                <ext:ComboBox runat="server" ID="txtdayarea" DisplayField="AreaName" QueryMode="Local"
                                    TypeAhead="true" ValueField="AreaName" Width="200" FieldLabel="城市" LabelWidth="60">
                                    <Store>
                                        <ext:Store ID="Store_AreaName" runat="server" AutoDataBind="true">
                                            <Model>
                                                <ext:Model ID="Model7" runat="server">
                                                    <Fields>
                                                        <ext:ModelField Name="AreaName" />
                                                    </Fields>
                                                </ext:Model>
                                            </Model>
                                        </ext:Store>
                                    </Store>
                                    <DirectEvents>
                                        <Change OnEvent="GetShop" />
                                    </DirectEvents>
                                </ext:ComboBox>
                                <ext:TextField runat="server" ID="selectshop" FieldLabel="店铺" LabelWidth="60" EmptyText="选择店铺">
                                    <Listeners>
                                        <Focus Handler="showshop();">
                                        </Focus>
                                    </Listeners>
                                </ext:TextField>
                                <ext:MultiCombo ID="comShop" runat="server" SelectionMode="All" FieldLabel="店铺" LabelWidth="60"
                                    Hidden="true" DisplayField="shopname" ValueField="shopid" Width="350">
                                    <Store>
                                        <ext:Store ID="Store_Shop" runat="server">
                                            <Model>
                                                <ext:Model ID="Model2" runat="server">
                                                    <Fields>
                                                        <ext:ModelField Name="shopid" />
                                                        <ext:ModelField Name="shopname" />
                                                    </Fields>
                                                </ext:Model>
                                            </Model>
                                        </ext:Store>
                                    </Store>
                                </ext:MultiCombo>
                                <ext:TextField runat="server" ID="txtdayshopname" FieldLabel="店铺简称" LabelWidth="60"
                                    EmptyText="输入店铺简称" />
                            </Items>
                        </ext:Toolbar>
                    </TopBar>
                    <Items>
                        <ext:GridPanel ID="GridPanel1" runat="server" Title="（日）数据分析" TitleAlign="Left" Height="500">
                            <Store>
                                <ext:Store ID="Store1" runat="server" PageSize="500" OnReadData="RefreshDataSet"
                                    OnSubmitData="Store1_Submit">
                                    <Model>
                                        <ext:Model ID="Model1" runat="server" IDProperty="美人计店铺编号">
                                            <Fields>
                                                <ext:ModelField Name="店铺代码" ServerMapping="ShopCode" />
                                                <ext:ModelField Name="店铺简称" ServerMapping="shopname" />
                                                <ext:ModelField Name="日期" ServerMapping="saledate" />
                                                <ext:ModelField Name="本期销售额" ServerMapping="saleamount" />
                                                <ext:ModelField Name="上期销售额" ServerMapping="saletbamount" />
                                                <ext:ModelField Name="销售额环比" ServerMapping="amtrate" />
                                                <ext:ModelField Name="本期成交件数" ServerMapping="saleqty" />
                                                <ext:ModelField Name="上期成交件数" ServerMapping="saletbqty" />
                                                <ext:ModelField Name="成交件数环比" ServerMapping="qtyrate" />
                                                <ext:ModelField Name="本期成交单数" ServerMapping="salecount" />
                                                <ext:ModelField Name="上期成交单数" ServerMapping="saletbcount" />
                                                <ext:ModelField Name="成交单数环比" ServerMapping="countrate" />
                                                <ext:ModelField Name="本期客流量" ServerMapping="kqty" />
                                                <ext:ModelField Name="上期客流量" ServerMapping="ktbqty" />
                                                <ext:ModelField Name="客流量环比" ServerMapping="kqtyrate" />
                                                <ext:ModelField Name="本期客单价" ServerMapping="salekdj" />
                                                <ext:ModelField Name="上期客单价" ServerMapping="saletbkdj" />
                                                <ext:ModelField Name="客单价环比" ServerMapping="kdjrate" />
                                                <ext:ModelField Name="本期连带率" ServerMapping="saleldv" />
                                                <ext:ModelField Name="上期连带率" ServerMapping="saletbldv" />
                                                <ext:ModelField Name="连带率环比" ServerMapping="ldvrate" />
                                                <ext:ModelField Name="本期转换率" ServerMapping="salezhl" />
                                                <ext:ModelField Name="上期转换率" ServerMapping="saletbzhl" />
                                                <ext:ModelField Name="转换率环比" ServerMapping="zhlrate" />
                                                <ext:ModelField Name="本期件单价" ServerMapping="salejdj" />
                                                <ext:ModelField Name="上期件单价" ServerMapping="saletbjdj" />
                                                <ext:ModelField Name="件单价环比" ServerMapping="jdjrate" />
                                            </Fields>
                                        </ext:Model>
                                    </Model>
                                </ext:Store>
                            </Store>
                            <ColumnModel>
                                <Columns>
                                    <ext:RowNumbererColumn runat="server" />
                                    <ext:Column ID="Column49" runat="server" Text="店铺代码" DataIndex="店铺代码" Width="80" />
                                    <ext:Column ID="Column1" runat="server" Text="店铺简称" DataIndex="店铺简称" Width="150" />
                                    <ext:Column ID="Column2" runat="server" Text="日期" DataIndex="日期" Width="100" />
                                    <ext:Column ID="Column3" runat="server" Text="本期结算额" DataIndex="本期销售额" Width="100" />
                                    <ext:Column ID="Column4" runat="server" Text="上期结算额" DataIndex="上期销售额" Width="100">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column35" runat="server" Text="销售额环比" DataIndex="销售额环比" Width="100">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column40" runat="server" Text="本期成交件数" DataIndex="本期成交件数" Width="120" />
                                    <ext:Column ID="Column41" runat="server" Text="上期成交件数" DataIndex="上期成交件数" Width="120">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column42" runat="server" Text="成交件数环比" DataIndex="成交件数环比" Width="120">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column9" runat="server" Text="本期成交单数" DataIndex="本期成交单数" Width="120" />
                                    <ext:Column ID="Column10" runat="server" Text="上期成交单数" DataIndex="上期成交单数" Width="120">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column36" runat="server" Text="成交单数环比" DataIndex="成交单数环比" Width="120">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column12" runat="server" Text="本期客流量" DataIndex="本期客流量" Width="100" />
                                    <ext:Column ID="Column11" runat="server" Text="上期客流量" DataIndex="上期客流量" Width="100">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column37" runat="server" Text="客流量环比" DataIndex="客流量环比" Width="100">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column13" runat="server" Text="本期客单价" DataIndex="本期客单价" Width="100" />
                                    <ext:Column ID="Column14" runat="server" Text="上期客单价" DataIndex="上期客单价" Width="100" />
                                    <ext:Column ID="Column38" runat="server" Text="客单价环比" DataIndex="客单价环比" Width="100">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column15" runat="server" Text="本期连带率" DataIndex="本期连带率" Width="100" />
                                    <ext:Column ID="Column16" runat="server" Text="上期连带率" DataIndex="上期连带率" Width="100">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column39" runat="server" Text="连带率环比" DataIndex="连带率环比" Width="100">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column43" runat="server" Text="本期件单价" DataIndex="本期件单价" Width="100" />
                                    <ext:Column ID="Column44" runat="server" Text="上期件单价" DataIndex="上期件单价" Width="100">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column45" runat="server" Text="件单价环比" DataIndex="件单价环比" Width="100">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column46" runat="server" Text="本期转换率" DataIndex="本期转换率" Width="100" />
                                    <ext:Column ID="Column47" runat="server" Text="上期转换率" DataIndex="上期转换率" Width="100">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column48" runat="server" Text="转换率环比" DataIndex="转换率环比" Width="100">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                </Columns>
                            </ColumnModel>
                            <BottomBar>
                                <ext:PagingToolbar ID="PagingToolbar1" runat="server">
                                    <Items>
                                        <ext:Label ID="Label1" runat="server" Text="每页显示:" />
                                        <ext:ToolbarSpacer ID="ToolbarSpacer1" runat="server" Width="10" />
                                        <ext:ComboBox ID="ComboBox1" runat="server" Width="80">
                                            <Items>
                                                <ext:ListItem Text="500" />
                                            </Items>
                                            <SelectedItems>
                                                <ext:ListItem Value="500" />
                                            </SelectedItems>
                                            <Listeners>
                                                <Select Handler="#{GridPanel1}.store.pageSize = parseInt(this.getValue(), 10); #{GridPanel1}.store.reload();" />
                                            </Listeners>
                                        </ext:ComboBox>
                                        <ext:Button ID="Button1" runat="server" Text="（日）查询" OnDirectClick="BtnQureyUser"
                                            UI="Info" Icon="Find">
                                            <DirectEvents>
                                                <Click>
                                                    <EventMask ShowMask="true" Msg="加载中...">
                                                    </EventMask>
                                                </Click>
                                            </DirectEvents>
                                        </ext:Button>
                                        <ext:Button ID="Button2" runat="server" Text="导出Excel" Icon="PageExcel">
                                            <Listeners>
                                                <Click Handler="exportData('xls');" />
                                            </Listeners>
                                        </ext:Button>
                                    </Items>
                                    <Plugins>
                                        <ext:ProgressBarPager ID="ProgressBarPager1" runat="server" />
                                    </Plugins>
                                </ext:PagingToolbar>
                            </BottomBar>
                        </ext:GridPanel>
                        <ext:GridPanel ID="GridPanel2" runat="server" Title="（周）数据分析" TitleAlign="Left" Height="550">
                            <Store>
                                <ext:Store ID="Store4" runat="server" PageSize="500" OnReadData="RefreshDataSet"
                                    OnSubmitData="Store2_Submit">
                                    <Model>
                                        <ext:Model ID="Model4" runat="server" IDProperty="美人计店铺编号">
                                            <Fields>
                                                <ext:ModelField Name="店铺代码" ServerMapping="ShopCode" />
                                                <ext:ModelField Name="店铺简称" ServerMapping="shopname" />
                                                <ext:ModelField Name="本期销售额" ServerMapping="saleamount" />
                                                <ext:ModelField Name="上期销售额" ServerMapping="saletbamount" />
                                                <ext:ModelField Name="销售额环比" ServerMapping="amtrate" />
                                                <ext:ModelField Name="本期成交件数" ServerMapping="saleqty" />
                                                <ext:ModelField Name="上期成交件数" ServerMapping="saletbqty" />
                                                <ext:ModelField Name="成交件数环比" ServerMapping="qtyrate" />
                                                <ext:ModelField Name="本期成交单数" ServerMapping="salecount" />
                                                <ext:ModelField Name="上期成交单数" ServerMapping="saletbcount" />
                                                <ext:ModelField Name="成交单数环比" ServerMapping="countrate" />
                                                <ext:ModelField Name="本期客流量" ServerMapping="kqty" />
                                                <ext:ModelField Name="上期客流量" ServerMapping="ktbqty" />
                                                <ext:ModelField Name="客流量环比" ServerMapping="kqtyrate" />
                                                <ext:ModelField Name="本期客单价" ServerMapping="salekdj" />
                                                <ext:ModelField Name="上期客单价" ServerMapping="saletbkdj" />
                                                <ext:ModelField Name="客单价环比" ServerMapping="kdjrate" />
                                                <ext:ModelField Name="本期连带率" ServerMapping="saleldv" />
                                                <ext:ModelField Name="上期连带率" ServerMapping="saletbldv" />
                                                <ext:ModelField Name="连带率环比" ServerMapping="ldvrate" />
                                                <ext:ModelField Name="本期转换率" ServerMapping="salezhl" />
                                                <ext:ModelField Name="上期转换率" ServerMapping="saletbzhl" />
                                                <ext:ModelField Name="转换率环比" ServerMapping="zhlrate" />
                                                <ext:ModelField Name="本期件单价" ServerMapping="salejdj" />
                                                <ext:ModelField Name="上期件单价" ServerMapping="saletbjdj" />
                                                <ext:ModelField Name="件单价环比" ServerMapping="jdjrate" />
                                            </Fields>
                                        </ext:Model>
                                    </Model>
                                </ext:Store>
                            </Store>
                            <ColumnModel>
                                <Columns>
                                    <ext:RowNumbererColumn ID="RowNumbererColumn1" runat="server" />
                                    <ext:Column ID="Column5" runat="server" Text="店铺代码" DataIndex="店铺代码" Width="80" />
                                    <ext:Column ID="Column7" runat="server" Text="店铺简称" DataIndex="店铺简称" Width="150" />
                                    <ext:Column ID="Column17" runat="server" Text="本期结算额" DataIndex="本期销售额" Width="100" />
                                    <ext:Column ID="Column18" runat="server" Text="上期结算额" DataIndex="上期销售额" Width="100">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column19" runat="server" Text="销售额环比" DataIndex="销售额环比" Width="100">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column20" runat="server" Text="本期成交件数" DataIndex="本期成交件数" Width="120" />
                                    <ext:Column ID="Column21" runat="server" Text="上期成交件数" DataIndex="上期成交件数" Width="120">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column22" runat="server" Text="成交件数环比" DataIndex="成交件数环比" Width="120">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column23" runat="server" Text="本期成交单数" DataIndex="本期成交单数" Width="120" />
                                    <ext:Column ID="Column24" runat="server" Text="上期成交单数" DataIndex="上期成交单数" Width="120">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column50" runat="server" Text="成交单数环比" DataIndex="成交单数环比" Width="120">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column51" runat="server" Text="本期客流量" DataIndex="本期客流量" Width="100" />
                                    <ext:Column ID="Column52" runat="server" Text="上期客流量" DataIndex="上期客流量" Width="100">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column53" runat="server" Text="客流量环比" DataIndex="客流量环比" Width="100">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column54" runat="server" Text="本期客单价" DataIndex="本期客单价" Width="100" />
                                    <ext:Column ID="Column55" runat="server" Text="上期客单价" DataIndex="上期客单价" Width="100" />
                                    <ext:Column ID="Column56" runat="server" Text="客单价环比" DataIndex="客单价环比" Width="100">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column57" runat="server" Text="本期连带率" DataIndex="本期连带率" Width="100" />
                                    <ext:Column ID="Column58" runat="server" Text="上期连带率" DataIndex="上期连带率" Width="100">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column59" runat="server" Text="连带率环比" DataIndex="连带率环比" Width="100">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column60" runat="server" Text="本期件单价" DataIndex="本期件单价" Width="100" />
                                    <ext:Column ID="Column61" runat="server" Text="上期件单价" DataIndex="上期件单价" Width="100">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column62" runat="server" Text="件单价环比" DataIndex="件单价环比" Width="100">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column63" runat="server" Text="本期转换率" DataIndex="本期转换率" Width="100" />
                                    <ext:Column ID="Column64" runat="server" Text="上期转换率" DataIndex="上期转换率" Width="100">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column65" runat="server" Text="转换率环比" DataIndex="转换率环比" Width="100">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                </Columns>
                            </ColumnModel>
                            <BottomBar>
                                <ext:PagingToolbar ID="PagingToolbar2" runat="server">
                                    <Items>
                                        <ext:Label ID="Label2" runat="server" Text="每页显示:" />
                                        <ext:ToolbarSpacer ID="ToolbarSpacer2" runat="server" Width="10" />
                                        <ext:ComboBox ID="ComboBox2" runat="server" Width="80">
                                            <Items>
                                                <ext:ListItem Text="500" />
                                            </Items>
                                            <SelectedItems>
                                                <ext:ListItem Value="500" />
                                            </SelectedItems>
                                            <Listeners>
                                                <Select Handler="#{GridPanel1}.store.pageSize = parseInt(this.getValue(), 10); #{GridPanel1}.store.reload();" />
                                            </Listeners>
                                        </ext:ComboBox>
                                        <ext:Button ID="Button3" runat="server" Text="（周）查询" OnDirectClick="BtnQureyUser2"
                                            UI="Info">
                                            <DirectEvents>
                                                <Click Timeout="900000">
                                                    <EventMask ShowMask="true" Msg="加载中...">
                                                    </EventMask>
                                                </Click>
                                            </DirectEvents>
                                        </ext:Button>
                                        <ext:Button ID="Button4" runat="server" Text="导出Excel" Icon="PageExcel">
                                            <Listeners>
                                                <Click Handler="exportData2('xls');" />
                                            </Listeners>
                                        </ext:Button>
                                    </Items>
                                    <Plugins>
                                        <ext:ProgressBarPager ID="ProgressBarPager2" runat="server" />
                                    </Plugins>
                                </ext:PagingToolbar>
                            </BottomBar>
                        </ext:GridPanel>
                        <ext:GridPanel ID="GridPanel3" runat="server" Title="（月）数据分析" TitleAlign="Left" Height="550">
                            <Store>
                                <ext:Store ID="Store2" runat="server" PageSize="500" OnReadData="RefreshDataSet"
                                    OnSubmitData="Store3_Submit">
                                    <Model>
                                        <ext:Model ID="Model3" runat="server" IDProperty="美人计店铺编号">
                                            <Fields>
                                                <ext:ModelField Name="店铺代码" ServerMapping="ShopCode" />
                                                <ext:ModelField Name="店铺简称" ServerMapping="shopname" />
                                                <ext:ModelField Name="本期销售额" ServerMapping="saleamount" />
                                                <ext:ModelField Name="上期销售额" ServerMapping="saletbamount" />
                                                <ext:ModelField Name="销售额环比" ServerMapping="amtrate" />
                                                <ext:ModelField Name="本期成交件数" ServerMapping="saleqty" />
                                                <ext:ModelField Name="上期成交件数" ServerMapping="saletbqty" />
                                                <ext:ModelField Name="成交件数环比" ServerMapping="qtyrate" />
                                                <ext:ModelField Name="本期成交单数" ServerMapping="salecount" />
                                                <ext:ModelField Name="上期成交单数" ServerMapping="saletbcount" />
                                                <ext:ModelField Name="成交单数环比" ServerMapping="countrate" />
                                                <ext:ModelField Name="本期客流量" ServerMapping="kqty" />
                                                <ext:ModelField Name="上期客流量" ServerMapping="ktbqty" />
                                                <ext:ModelField Name="客流量环比" ServerMapping="kqtyrate" />
                                                <ext:ModelField Name="本期客单价" ServerMapping="salekdj" />
                                                <ext:ModelField Name="上期客单价" ServerMapping="saletbkdj" />
                                                <ext:ModelField Name="客单价环比" ServerMapping="kdjrate" />
                                                <ext:ModelField Name="本期连带率" ServerMapping="saleldv" />
                                                <ext:ModelField Name="上期连带率" ServerMapping="saletbldv" />
                                                <ext:ModelField Name="连带率环比" ServerMapping="ldvrate" />
                                                <ext:ModelField Name="本期转换率" ServerMapping="salezhl" />
                                                <ext:ModelField Name="上期转换率" ServerMapping="saletbzhl" />
                                                <ext:ModelField Name="转换率环比" ServerMapping="zhlrate" />
                                                <ext:ModelField Name="本期件单价" ServerMapping="salejdj" />
                                                <ext:ModelField Name="上期件单价" ServerMapping="saletbjdj" />
                                                <ext:ModelField Name="件单价环比" ServerMapping="jdjrate" />
                                            </Fields>
                                        </ext:Model>
                                    </Model>
                                </ext:Store>
                            </Store>
                            <ColumnModel>
                                <Columns>
                                    <ext:RowNumbererColumn ID="RowNumbererColumn2" runat="server" />
                                    <ext:Column ID="Column6" runat="server" Text="店铺代码" DataIndex="店铺代码" Width="80" />
                                    <ext:Column ID="Column8" runat="server" Text="店铺简称" DataIndex="店铺简称" Width="150" />
                                    <ext:Column ID="Column26" runat="server" Text="本期结算额" DataIndex="本期销售额" Width="100" />
                                    <ext:Column ID="Column27" runat="server" Text="上期结算额" DataIndex="上期销售额" Width="100">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column28" runat="server" Text="销售额环比" DataIndex="销售额环比" Width="100">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column29" runat="server" Text="本期成交件数" DataIndex="本期成交件数" Width="120" />
                                    <ext:Column ID="Column30" runat="server" Text="上期成交件数" DataIndex="上期成交件数" Width="120">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column31" runat="server" Text="成交件数环比" DataIndex="成交件数环比" Width="120">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column32" runat="server" Text="本期成交单数" DataIndex="本期成交单数" Width="120" />
                                    <ext:Column ID="Column33" runat="server" Text="上期成交单数" DataIndex="上期成交单数" Width="120">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column34" runat="server" Text="成交单数环比" DataIndex="成交单数环比" Width="120">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column66" runat="server" Text="本期客流量" DataIndex="本期客流量" Width="100" />
                                    <ext:Column ID="Column67" runat="server" Text="上期客流量" DataIndex="上期客流量" Width="100">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column68" runat="server" Text="客流量环比" DataIndex="客流量环比" Width="100">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column69" runat="server" Text="本期客单价" DataIndex="本期客单价" Width="100" />
                                    <ext:Column ID="Column70" runat="server" Text="上期客单价" DataIndex="上期客单价" Width="100" />
                                    <ext:Column ID="Column71" runat="server" Text="客单价环比" DataIndex="客单价环比" Width="100">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column72" runat="server" Text="本期连带率" DataIndex="本期连带率" Width="100" />
                                    <ext:Column ID="Column73" runat="server" Text="上期连带率" DataIndex="上期连带率" Width="100">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column74" runat="server" Text="连带率环比" DataIndex="连带率环比" Width="100">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column75" runat="server" Text="本期件单价" DataIndex="本期件单价" Width="100" />
                                    <ext:Column ID="Column76" runat="server" Text="上期件单价" DataIndex="上期件单价" Width="100">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column77" runat="server" Text="件单价环比" DataIndex="件单价环比" Width="100">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                    <ext:Column ID="Column78" runat="server" Text="本期转换率" DataIndex="本期转换率" Width="100" />
                                    <ext:Column ID="Column79" runat="server" Text="上期转换率" DataIndex="上期转换率" Width="100">
                                        <Renderer Fn="tbchange" />
                                    </ext:Column>
                                    <ext:Column ID="Column80" runat="server" Text="转换率环比" DataIndex="转换率环比" Width="100">
                                        <Renderer Fn="change" />
                                    </ext:Column>
                                </Columns>
                            </ColumnModel>
                            <BottomBar>
                                <ext:PagingToolbar ID="PagingToolbar3" runat="server">
                                    <Items>
                                        <ext:Label ID="Label3" runat="server" Text="每页显示:" />
                                        <ext:ToolbarSpacer ID="ToolbarSpacer3" runat="server" Width="10" />
                                        <ext:ComboBox ID="ComboBox3" runat="server" Width="80">
                                            <Items>
                                                <ext:ListItem Text="500" />
                                            </Items>
                                            <SelectedItems>
                                                <ext:ListItem Value="500" />
                                            </SelectedItems>
                                            <Listeners>
                                                <Select Handler="#{GridPanel1}.store.pageSize = parseInt(this.getValue(), 10); #{GridPanel1}.store.reload();" />
                                            </Listeners>
                                        </ext:ComboBox>
                                        <ext:Button ID="Button5" runat="server" Text="（月）查询" OnDirectClick="BtnQureyUser3"
                                            UI="Info">
                                            <DirectEvents>
                                                <Click Timeout="900000">
                                                    <EventMask ShowMask="true" Msg="加载中...">
                                                    </EventMask>
                                                </Click>
                                            </DirectEvents>
                                        </ext:Button>
                                        <ext:Button ID="Button6" runat="server" Text="导出Excel" Icon="PageExcel">
                                            <Listeners>
                                                <Click Handler="exportData3('xls');" />
                                            </Listeners>
                                        </ext:Button>
                                    </Items>
                                    <Plugins>
                                        <ext:ProgressBarPager ID="ProgressBarPager3" runat="server" />
                                    </Plugins>
                                </ext:PagingToolbar>
                            </BottomBar>
                        </ext:GridPanel>
                    </Items>
                </ext:TabPanel>
            </Items>
        </ext:Viewport>
    </div>
    <div id="my-shop" style="display: none;">
        <div style="padding: 3px;">
            <label runat="server" id="select_shop" style="display: none;">
            </label>
            已选择店铺：
            <textarea id="txt_shop" style="width: 750px;" rows="2"></textarea>
        </div>
        <div>
            店铺：<input id="txt_shopname" type="text" style="width: 160px;" placeholder="输入店铺名称" />
            <input id="btn_findshop" type="button" value="查找" />
            <input id="chkclear" type="button" value="清除" />
        </div>
        <div id="shop-list" style="position: relative; height: 350px; overflow: auto;">
        </div>
    </div>
    </form>
</body>
</html>
